Re: trouble with db-restore

>Heiko Irrgang <irrgang@SC-Networks.de> writes:
>>  i simply use pg_dumpall with no params for dumping the
>>  data, but when i used psql for restoring the data,
>>  every view was created as a table and was filled up
>>  with the data which the view had been delivered at
>>  the time of the backup.
>
>This is extremely surprising; I've never heard of such a report before.
>
>It would seem that pg_dump failed to recognize your views as being
>views.  The only theory I can come up with offhand is that you are
>using a pg_dump version that is not compatible with the database
>server version you are running.  Since you have said nothing about
>what version you are using, it's hard to guess more ...
>
>            regards, tom lane

On the first server, where the backup was done
a binary distribution was installed
(think it was from postgresql.org). The filenames were called:
postgresql-7.0.2-3mdk.i686.rpm, etc

On the new server, there is 7.0.2 too, but compiled from source,
dont know if this could be a hint. i'm shure that the
pg_dump used was the version which was delivered with the
binaries.

The whole thing is running on a turbolinux turbocluster server 4.0,
kernel 2.2.12, glibc 2.1.2
--
SC-Networks                             www: www.SC-Networks.de
Web Design, Netzwerke,
3D Animation und Multimedia
Heiko Irrgang                           Tel.: 08856/9392-00
Im Thal 2                               Fax:  08856/9392-01

82377 Penzberg                          Mail: Irrgang@SC-Networks.de